package com.budwk.app.sqfw.models;

import com.budwk.starter.common.openapi.annotation.ApiModel;
import com.budwk.starter.common.openapi.annotation.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;
import org.nutz.dao.entity.annotation.*;
import org.nutz.dao.interceptor.annotation.PrevInsert;

import java.io.Serializable;
import java.util.Date;

/**
 * @author LJT
 * 数据采集表总表
 */
@Data
@Accessors(chain = true)
@Table("shequ.sqfw_datamange_community")
@Comment("社区数据管理总表")
@ApiModel(description = "社区数据管理总表")
public class Sqfw_datamange_community implements Serializable {

    private static final long serialVersionUID = 1L;

    @Column
    @Name
    @Comment("编号")
    @ApiModelProperty(description = "ID")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    @PrevInsert(uu32 = true, nullEffective = true)
    private String id;

    @Column("sqfw_summary_id")
    @Comment("社区数据id")
    @ApiModelProperty(description = "社区数据id")
    @ColDefine(type = ColType.VARCHAR, width = 64)
    private String sqfwSummaryId;

    @Column("latest_sqfw_summary_id")
    @Comment("最新的社区数据id")
    @ApiModelProperty(description = "最新的社区数据id")
    @ColDefine(type = ColType.TEXT)
    private String latestSqfwSummaryId;

    @Column("common_id")
    @Comment("公共标记id, 标记为同一组数据")
    @ApiModelProperty(description = "公共标记id")
    @ColDefine(type = ColType.VARCHAR, width = 64)
    private String commonId;

    @Column("template_id")
    @Comment("文件模板id")
    @ApiModelProperty(description = "文件模板id")
    @ColDefine(type = ColType.VARCHAR, width = 64)
    private String templateId;

    @Column("col_num")
    @Comment("单元格列数")
    @ApiModelProperty(description = "单元格列数")
    @ColDefine(type = ColType.VARCHAR, width = 64)
    private String colNum;

    @Column("unit_id")
    @Comment("单位id")
    @ApiModelProperty(description = "单位id")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String unitId;

    @Column("unit_name")
    @Comment("单位名称（巡查单位）")
    @ApiModelProperty(description = "单位名称")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String unitName;

    @Column("create_date")
    @Comment("创建时间")
    @ApiModelProperty(description = "创建时间")
    @ColDefine(type = ColType.TIMESTAMP, width = 120)
    private Date createDate;

    @Column("create_by")
    @Comment("上传人")
    @ApiModelProperty(description = "服务id")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String createBy;

    @Column("create_user_name")
    @Comment("上传人名字(巡查人员名字)")
    @ApiModelProperty(description = "服务id")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String createUserName;

    @Column("create_user_phone")
    @Comment("上传人手机")
    @ApiModelProperty(description = "服务id")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String createUserPhone;

    @Column("update_date")
    @Comment("更新时间")
    @ApiModelProperty(description = "更新时间")
    @ColDefine(type = ColType.TIMESTAMP, width = 120)
    private Date updateDate;

    @Column("update_by")
    @Comment("修改人")
    @ApiModelProperty(description = "修改人")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String updateBy;

    @Column("update_user_name")
    @Comment("修改人姓名")
    @ApiModelProperty(description = "修改人姓名")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String updateUserName;

    @Column("update_user_phone")
    @Comment("修改人手机")
    @ApiModelProperty(description = "修改人手机")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String updateUserPhone;

    @Column("type")
    @Comment("类型 消防 12345 等")
    @ApiModelProperty(description = "服务id")
    @ColDefine(type = ColType.VARCHAR, width = 120)
    private String type;

    @Column("province")
    @Comment("省份")
    @ApiModelProperty(description = "省份")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String province;

    @Column("city")
    @Comment("市")
    @ApiModelProperty(description = "市")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String city;

    @Column("district")
    @Comment("区")
    @ApiModelProperty(description = "区")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String district;

    @Column("county")
    @Comment("街道")
    @ApiModelProperty(description = "街道")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String county;

    @Column("community")
    @Comment("社区")
    @ApiModelProperty(description = "社区")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String community;

    @Column("grid")
    @Comment("网格")
    @ApiModelProperty(description = "网格")
    @ColDefine(type = ColType.VARCHAR, width = 255)
    private String grid;

    @Column("excel_data")
    @Comment("excel_data")
    @ApiModelProperty(description = "excel在线数据")
    @ColDefine(type = ColType.TEXT)
    private String excelData;

    @Column("excel_seg")
    @Comment("excel_seg")
    @ApiModelProperty(description = "excel结构标识,body, header")
    @ColDefine(type = ColType.VARCHAR, width = 10)
    private String excelSeg;

    @Column("param_data")
    @Comment("param_data")
    @ApiModelProperty(description = "采样元数据")
    @ColDefine(type = ColType.TEXT)
    private String paramData;

    @Column("del_flag")
    @Comment("删除标志")
    @ApiModelProperty(description = "删除标志")
    @ColDefine(type = ColType.BOOLEAN, width = 1)
    private Boolean delFlag;

    @Column("shops_base_info_id")
    @Comment("商铺基本信息表id")
    @ApiModelProperty(description = "商铺基本信息表id")
    @ColDefine(type = ColType.VARCHAR, width = 50)
    public String shopsBaseInfoId;

    @ApiModelProperty(description = "拜访次数")
    private Integer visitNum;

    @Column("fill_date")
    @Comment("填表日期")
    @ApiModelProperty(description = "填表日期")
    @ColDefine(type = ColType.DATETIME, width = 120)
    private Date fillDate;
}
